package com.example.shengyin.dao;

import com.example.shengyin.entity.Subject;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public interface SubjectMapper {
    public Subject select(@Param("id")Long id);
    public List<Subject> list(@Param("pagestart")int pagestart, @Param("limit")int limit,@Param("cname")String cname, @Param("poster")String poster);
    public List<Subject> list2(@Param("cname")String cname);
    public List<Subject> list3(@Param("pagestart")int pagestart, @Param("limit")int limit);

    public int count2(@Param("cname")String cname);
    public int count3(@Param("cname")String cname);
    public int count(@Param("cname")String cname, @Param("poster")String poster);
    public int insert(Subject dSubject);
    public int update(Subject dSubject);
    public int delete(@Param("id")int id);
    public int deleteByIds(@Param("ids")String ids);
    public List<String> findCname();
    public List<Subject> page1(@Param("cname")String cname);
    public List<Subject> getAll(long id);

}
